package com.kady.Dao.impl;


import com.kady.Dao.MenuDao;
import com.kady.entity.Menu;

import java.sql.SQLException;
import java.util.List;

/**
 * \* Created with IntelliJ IDEA.
 * \* User: kady
 * \* Date: 2021/3/23
 * \* Time: 17:15
 * \* 千峰JAVA2101班
 * \* Description: 菜单Dao
 * \
 */

public class MenuDaoImpl extends BaseDao implements MenuDao {
    /**
     * 查询菜单列表
     */
    @Override
    public List<Menu> selectMenuList() throws SQLException {
        String sql = "SELECT menu_id menuId,menu_name menuName, menu_url menuUrl FROM t_menu; ";
        List<Menu> res = selectList(Menu.class,sql,null);
        return res;
    }
}
